create table sys_job
(
    job_id          bigint identity,
    job_name        nvarchar(64)
        constraint DF_sys_job_job_name default ''         not null,
    job_group       nvarchar(64)
        constraint DF_sys_job_job_group default 'DEFAULT' not null,
    invoke_target   nvarchar(500)                         not null,
    cron_expression nvarchar(255)
        constraint DF_sys_job_cron_expression default '',
    misfire_policy  nvarchar(20)
        constraint DF_sys_job_misfire_policy default '3',
    concurrent      nchar
        constraint DF_sys_job_concurrent default '1',
    status          nchar
        constraint DF_sys_job_status default '0',
    create_by       nvarchar(64)
        constraint DF_sys_job_create_by default '',
    create_time     datetime2(0),
    update_by       nvarchar(64)
        constraint DF_sys_job_update_by default '',
    update_time     datetime2(0),
    remark          nvarchar(500)
        constraint DF_sys_job_remark default '',
    constraint PK__sys_job__2E0E56DCE32A3DF1
        primary key (job_id, job_name, job_group)
)
go

exec sp_addextendedproperty 'MS_Description', '定时任务调度表', 'SCHEMA', 'dbo', 'TABLE', 'sys_job'
go

exec sp_addextendedproperty 'MS_Description', '任务ID', 'SCHEMA', 'dbo', 'TABLE', 'sys_job', 'COLUMN', 'job_id'
go

exec sp_addextendedproperty 'MS_Description', '任务名称', 'SCHEMA', 'dbo', 'TABLE', 'sys_job', 'COLUMN', 'job_name'
go

exec sp_addextendedproperty 'MS_Description', '任务组名', 'SCHEMA', 'dbo', 'TABLE', 'sys_job', 'COLUMN', 'job_group'
go

exec sp_addextendedproperty 'MS_Description', '调用目标字符串', 'SCHEMA', 'dbo', 'TABLE', 'sys_job', 'COLUMN', 'invoke_target'
go

exec sp_addextendedproperty 'MS_Description', 'cron执行表达式', 'SCHEMA', 'dbo', 'TABLE', 'sys_job', 'COLUMN',
     'cron_expression'
go

exec sp_addextendedproperty 'MS_Description', '计划执行错误策略（1立即执行 2执行一次 3放弃执行）', 'SCHEMA', 'dbo', 'TABLE', 'sys_job',
     'COLUMN', 'misfire_policy'
go

exec sp_addextendedproperty 'MS_Description', '是否并发执行（0允许 1禁止）', 'SCHEMA', 'dbo', 'TABLE', 'sys_job', 'COLUMN',
     'concurrent'
go

exec sp_addextendedproperty 'MS_Description', '状态（0正常 1暂停）', 'SCHEMA', 'dbo', 'TABLE', 'sys_job', 'COLUMN', 'status'
go

exec sp_addextendedproperty 'MS_Description', '创建者', 'SCHEMA', 'dbo', 'TABLE', 'sys_job', 'COLUMN', 'create_by'
go

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 'sys_job', 'COLUMN', 'create_time'
go

exec sp_addextendedproperty 'MS_Description', '更新者', 'SCHEMA', 'dbo', 'TABLE', 'sys_job', 'COLUMN', 'update_by'
go

exec sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', 'dbo', 'TABLE', 'sys_job', 'COLUMN', 'update_time'
go

exec sp_addextendedproperty 'MS_Description', '备注信息', 'SCHEMA', 'dbo', 'TABLE', 'sys_job', 'COLUMN', 'remark'
go

INSERT INTO [ry-vue].dbo.sys_job (job_id, job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, update_by, update_time, remark) VALUES (1, N'系统默认（无参）', N'DEFAULT', N'ryTask.ryNoParams', N'0/10 * * * * ?', N'3', N'1', N'1', N'admin', N'2021-12-03 22:22:28', N'admin', N'2021-12-04 13:16:24', N'');
INSERT INTO [ry-vue].dbo.sys_job (job_id, job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, update_by, update_time, remark) VALUES (2, N'系统默认（有参）', N'DEFAULT', N'ryTask.ryParams(''ry'')', N'0/15 * * * * ?', N'3', N'1', N'1', N'admin', N'2021-12-03 22:22:28', N'', null, N'');
INSERT INTO [ry-vue].dbo.sys_job (job_id, job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, update_by, update_time, remark) VALUES (3, N'系统默认（多参）', N'DEFAULT', N'ryTask.ryMultipleParams(''ry'', true, 2000L, 316.50D, 100)', N'0/20 * * * * ?', N'3', N'1', N'1', N'admin', N'2021-12-03 22:22:28', N'', null, N'');